Synchronize a "Calendar View" with Outlook 2007
Hi everyone, I've few views created in one of my MOSS 2007 site calendar and I am trying to synchronize only one view from that calendar with Outlook 2007. When I synchronize with 'connect to' option from the calendar it takes all the events from that calendar (in other words NOT limited to my particular view). Is there any way only that filtered events are synchronized with Outlook? Alternatively if I can create a new calendar based on that view (filtered events) I am fine too i.e. whatever changes made to the original calendar (hence the view in interest) the new calendar would reflect that. Thus avoiding creating a new calendar. I would prefer solution with minimum programming involved. Any suggestions would be greatly appreciated. Thank you in advance! Daisy
January 3rd, 2010 10:50pm

Outlook currently doesn't understand the views in SharePoint so all content is synchronized. I haven't done it with a calendar, but I know with tasks you have the option of adding a custom filter on the client (Outlook) side. Try editing the properties of the connection and see if it gives you the option. SharePoint MVP | Developer | Administrator | Speaker-- Twitter -- Blog - http://nextconnect.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
January 3rd, 2010 11:32pm

There's a way to create a custom view in Outlook, if that's something you want to delve into. It depends on how many users need this view in Outlook. If the filter is based on some SharePoint field that Outlook doesn't know about, though, it won't be possible.I recommend creating a second calendar. Then, you can create a SharePoint designer workflow. Connect the workflow to the first calendar. What's the filter criteria? Whatever the filter criteria is, make that as the workflow condition. Then, the action would be to simply copy that item over to the other calendar.Laura Rogers, MCSE, MCTS SharePoint911: SharePoint Consulting Blog: http://www.sharepoint911.com/blogs/laura Twitter: WonderLaura
January 4th, 2010 12:13pm

Thank you Mike for the clarification - I kind of guessed this as a limitation. Laura - Yes the filter is based on a custom sharepoint field. So I understand I'll have to take the Workflow solution you suggested. Do I create the 2nd Calendar with the same structure (as the existing calendar) first before I create the workflow? I would give this a try and let you know the outcome. Thank you very much!Daisy
Free Windows Admin Tool Kit Click here and download it now
January 4th, 2010 1:00pm

Yes, it would be a great idea to save calendar #1 as a template (minus the data), and then create the 2nd calendar from that template.Laura Rogers, MCSE, MCTS SharePoint911: SharePoint Consulting Blog: http://www.sharepoint911.com/blogs/laura Twitter: WonderLaura
January 4th, 2010 3:02pm

@Laura - it's great my 2nd calendar is updating with any update/ new insert to the 1st calendar. Exactly what I wanted. I just have one quick question to make this perfect: :)When I'm using 'Copy list item' - both the calendars seem need to be under the same site. Ideally I would prefer the 2nd calendar be on a different site (within the same site collection - but on a seperate tab). Is this something achievable? Thank you again - you are very helpful!Daisy
Free Windows Admin Tool Kit Click here and download it now
January 4th, 2010 11:25pm

Hi Laura, I am following your suggestion on creating a second calendar and then having a workflow update that calendar from the main calendar. However, what happens if the data changes on a event that was copied over to the second calendar. How does the copied data get updated to the changed data? Is there a workflow that can help update the record in the second calendar? Thanks!
April 13th, 2012 5:15pm

When you create the copy of the calendar item and will need to refer to it later when a workflow needs to change the item, you should create an extra field in the second calendar called "Associated ID" or something, and hide this field. Then, when the item first gets created as a copy, populate the "associated id" field with the ID of the item that you're copying. Then, you'd need to run a workflow "on change" and when a calendar item gets changed, then you'd have to use the "update item" action and update the item where "Associated ID" is equal to the ID of the item that's getting changed.Laura Rogers SharePoint911: SharePoint Consulting Blog: http://www.sharepoint911.com/blogs/laura Twitter: WonderLaura Books:Beginning SharePoint 2010: Building Business Solutions with SharePoint Using InfoPath 2010 with Microsoft SharePoint 2010 Step by Step
Free Windows Admin Tool Kit Click here and download it now
April 16th, 2012 11:57am

Hi Laura, I created an "unique identifier" that copies to the new list. However, now I am doing recurring events and when the event is changed in the main calendar, the change does appear in the second calendar, however, the original event is still visible and when you click on it you get the error "Item does not exist. It may have been deleted by another user." Do you have any ideas on how to get rid of the original event with the error or a different way to update the second calendar? Thanks!
May 1st, 2012 5:30pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics